Microsoft Excel : Advanced

----SPECIAL OFFER----SPECIAL OFFER----SPECIAL OFFER----

***Complimentary Course Bundle 5 Courses + PDF Certificates Absolutely FREE***

**5 Free Courses Included**

• Course 1 : Organising and Efficiency Skills
• Course 2 : Microsoft Project
• Course 3 : Microsoft Project 2016
• Course 4 : QuickBooks Pro 2016
• Course 5 :Facilitation Skills

**FREE PDF Certificates Included**

Microsoft Excel 2016 - Advanced

Created by a highly skilled professional, this course will guide learners through Microsoft Excel 2016. This computer program is commonly used in the world of work, so no matter what industry you hope to break into, this course will give your CV a boost. Whether you’re someone who is already working, or if you’re just starting out, this course is packed with useful information to help you succeed

This course covers advanced level functions of Microsoft Excel, such as data validation, slicers and timelines, and the running a macro. If you’re someone who has used Excel before, but you don’t know how to get the most out of it, then this course is for you. So, become a master of Excel with Next Learn Academy today.

Learning with Next Learn Academy has many advantages. The course material is delivered straight to you, and can be adapted to fit in with your lifestyle. It is created by experts within the industry, meaning you are receiving accurate information, which is up-to-date and easy to understand.

Get Started Today!!

• Accredited by CPD
• Unlimited Access for 365 Days
• Free PDF Certificate Included

Why You Should Study at Next Learn Academy?

Online learning is flexible, convenient and allows you to balance life's other commitments with higher education. Next Learn Academy offers an extensive range of online courses with a variety of rich material and resources. These resources will help you connect to peers and expert tutors and build on your skills and knowledge. Next Learn Academy is a reliable online education provider with a strong reputation providing meticulously designed courses to help you kick-start your professional journey in the best possible way. We are bound to provide you with the best online education experience and help reach the next level in your career.

• Text Functions 36:56

  • 1: Text Functions Preview 36:56

• Date And Time Functions 28:36

  • 2: Date And Time Functions 28:36

• Understanding The Functions 29:56

  • 3: Module 3 -Part 1- Recap 01:42
  • 4: Module 3 -Part 2 -Nested If With =max() Function 07:11
  • 5: Module 3 - Part 3 - Max & Ifs - & And & Or Using If Function 05:36
  • 6: Module 3 - Part 4 - Nested If With Multiple Ifs 06:24
  • 7: Module 3 - part 5 - If Functions With =and() & =or() Functions 09:03

• Working With VLOOKUP 26:40

  • 8: Module 4- VLOOKUP To Find The Nearest Match 09:38
  • 9: Module 4- VLOOKUP To Find The Exact Match 17:02

• Match And Index Functions 21:34

  • 10: Match And Index Functions 21:34

• Data Validation 12:12

  • 11: Data Validation 12:12

• Protecting Worksheets & Workbooks 07:56

  • 12: Protecting Worksheets & Workbooks 07:56

• Working With Templates 09:53

  • 13: Working With Templates 09:53

• Exploring Pivot Table 57:03

  • 14: Creating, Rearranging And Updating A Pivot Table 17:49
  • 15: Filtering And Grouping Data In A Pivot Table 15:38
  • 16: Creating A Pivot Chart 11:08
  • 17: Creating a Pivot chart 12:28

• How to work with a Macro? 29:19

  • 18: Recording a macro in a macro enabled workbook (using relative references ) 11:11
  • 19: Running a macro and assigning it to objects 06:33
  • 20: Editing and deleting a macro 11:35

• Conclusion 01:14

  • 21: Conclusion 01:14

• Exams 43:00

  • 22: Mock Exam Microsoft Excel Advanced 22:00
  • 23: Final Exam Microsoft Excel Advanced 21:00

COURSE CURRICULUM

Module 01 : Text Functions

• Function Concatenate
• Text case Functions
• Other additional Functions
  
• Course structure and Outline (click the free preview button above)

Module 02 : Date & Time Functions

• Input Date in different formats
• Input the Days

Module 03 : Understanding the functions

• Recap
• Nested IF with =MAX () Function
• Max & Ifs - & and & OR Using If Function
• Nested IF with multiple Ifs
• IF functions with =AND () & =OR () functions

Module 04 : Working with VLOOKUP

• VLOOKUP to find the nearest match
• VLOOKUP to find an exact match

Module 05 : Match & Index Functions

• Index
• Index and Match
• Two-way Lookup
• Case-sensitive Lookup
• Left Lookup

Module 06 : Data Validation

• Control only valid data is entered in the spreadsheets
• How to apply data validation in the spreadsheets
• Create a dropdown list
• Error message

Module 07 : Protecting Worksheets & Workbooks

• Locked cells in excel
• Password protection

Module 08 : Working with Templates

• Get started in excel using templates
• Free and Premium templates

Module 09 : Exploring Pivot Tables

• Creating, rearranging and updating a Pivot Table
• Filtering and grouping data in a Pivot Table
• Slicers and timelines
• Creating a Pivot chart

Module 10 : How to work with a Macro?

• Recording a macro in a macro-enabled workbook (using relative references)
• Running a macro and assigning it to objects
• Editing and deleting a macro

What Will I Learn?

• Learn how to change print settings and print a document
• Learn to navigate the Excel 2016 interface effectively
• Learn to navigate, format and select texts
• Learn to create, open and save documents
• Understand how to work and customise the quick access toolbar

Method of Assessment

At the end of the course, learners will take an online multiple choice questions assessment test. This online multiple choice questions assessment test is marked automatically so that you will receive an instant grade and know whether you have passed the course.

Certification

Upon the successful completion of the course, you will be awarded the ‘Microsoft Excel 2016 - Advanced’ certificate by CPD. You will receive a FREE E-certificate (PDF format) and a Printed Certificate absolutely FREE, with an applicable delivery fee upon completing the course.

Access Duration

The course will be directly delivered to you, and you have 12 months access to the online learning platform from the date you joined the course. The course is self-paced and you can complete it in stages, revisiting the lectures at any time.

Awarding Body

CPD is an internationally recognised accrediting body that will make your CV standout and encourage employers to see your motivation at expanding your skills and knowledge in an enterprise.

Other Benefits

• High-quality e-learning study materials.
• Tutorials/materials from industry-leading experts.
• 24/7 Access to the Learning Portal.
• Recognised Accredited Certification

This course is recommended for,

• Individuals interested in learning Excel 2016 for the first time
• Anyone who wants to take a refresher course in Excel 2016
• Individuals working in an office environment like Admin Assistants, PA’s, Executive Assistants and Secretaries

• This course requires no formal prerequisites and this certification is open to everyone

Once you successfully complete the Microsoft Excel 2016 Advanced, it will demonstrate your understanding of how to use Microsoft Excel 2016 Advanced effectively in your place of work. The course will give you the confidence to apply Word in your day to day tasks, and your new-found skills and knowledge will impress your current employer or potential employers, in the process.

Reed courses certificate of completion

Digital certificate - Included